Introduction

Opera 3 SQL SE offers a breadth of functionality in the Financial, Supply Chain Management, Payroll and Personnel applications, and includes foreign currencies transactions, reporting for Import / Export transactions and Pegasus XRL reporting.

Opera 3 SQL SE lays the foundations for the future by using 64-bit Microsoft .NET framework technologies in the latest 64-bit Windows Server and Windows desktop operating systems, with Microsoft SQL Server being used for the data store. This is a client-server application that uses the Pegasus Opera Service to manage the communication between the PC workstations and the server as well as monitoring the users in the system.

With Opera 3 SQL SE the security of company data is of the utmost importance.

This decision is supported by the choice of Microsoft SQL Server to provide data storage, the design of the Pegasus Opera Service as the secure method of communication between Microsoft SQL Server and Opera 3 SQL SE, and the introduction of the secure Opera 3 SQL SE Windows File Repository for the files in Windows.

Heavy duty ‘data intensive processes’ - that could take some time to complete - are run from the PC workstations but all the processing work is done on the Opera 3 SQL SE server. As well as minimising the impact on your IT network, your workstations are not used at all for by a data intensive process, and so can be used for other tasks.

Opera 3 SQL SE is a fully integrated system of Financial, Supply Chain Management, Payroll and Personnel applications that blends the traditional with a new user experience.

You can buy the applications that you need, when you need them, and expand the solution as your business grows. And the functionality in each application in Opera 3 SQL SE can be customised to your requirements.

Each application in Opera 3 SQL SE includes a number of built in reports. Integration with Microsoft Excel is available for some of those reports. They can be printed or saved as PDF documents in a secure location.

The installation of the Opera 3 SQL SE server and the client workstation software is straightforward. Details of the supported software environments and the initial configuration tasks that need to be completed on the server are included in the Installation & Implementation guide - available at docs.pegasus.co.uk.

The administration and monitoring of Opera 3 SQL SE are achieved by using a separate application that is installed at the same time as the Opera 3 SQL SE server software. The Server Administration and Monitoring application is a server-side application for configuring the Opera 3 SQL SE server software, entering licence and activation details, configuring email settings, creating company records, monitoring database details and managing bespoke applications.

There are strict database rules for data in Opera 3 SQL SE. These rules make sure that dates and values are recorded correctly and related database tables reconcile - for example invoice totals must equate with the sum of the invoice detail lines. The database 'health checker' in the Server Administration and Monitoring application completes these checks prior to the data migration from other editions of Opera 3.